
#version check
import sqlalchemy
# print(sqlalchemy.__version__)


from base import session, User




# Base.metadata.create_all(engine)
ed_user = User(name='ed', fullname='Ed Jones', password='edspassword')


session.add(ed_user)

our_user = session.query(User).filter_by(name='ed').first()
print(our_user)
print(ed_user is our_user)
ed_user.password = 'f8s7ccs'
session.add_all([User(name='wendy', fullname='Wendy Williams', password='foobar'),User(name='mary', fullname='Mary Contrary', password='xxg527'),User(name='fred', fullname='Fred Flinstone', password='blah')])

print(session.dirty)
print(session.new)
# session.commit()
print(ed_user.id)
